package com.ruoyi.system.Fdongbei.mapper;

import com.ruoyi.system.Fdongbei.domain.XzName;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * Mapper 接口
 * </p>
 *
 * @author fufeng
 * @since 2024-12-26
 */
public interface XzNameMapper {


    @Select(" select*from xz_name where #{zz}>=DZ and #{zz}<GZ and KFXM='杂质'and HWMC=#{hth} ")
    XzName selectxznameZz(@Param("zz") String zz, @Param("hth") String hth);

    @Select(" select*from xz_name where #{bwsls}>=DZ and #{bwsls}<GZ and KFXM='不完善'and HWMC=#{hth} ")
    XzName selectxznameBws(@Param("bwsls") String bwsls, @Param("hth") String hth);


    @Select(" select*from xz_name where #{mbl}>=DZ and #{mbl}<GZ and KFXM='霉变'and HWMC=#{hth} ")
    XzName selectxznameMbl(@Param("mbl") String mbl, @Param("hth") String hth);

    @Select(" select*from xz_name where #{bn}>=DZ and #{bn}<GZ and KFXM='白糯'and HWMC=#{hth} ")
    XzName selectxznameBn(@Param("bn") String bn, @Param("hth") String hth);

    @Select(" select*from xz_name where #{sf}>=DZ and #{sf}<GZ and KFXM='水分'and HWMC=#{hth} ")
    XzName selectxznamesf(@Param("sf") String sf, @Param("hth") String hth);


}
